Client Profit

The Client Profit report gives the firm an overall picture of profitability for each client, showing production costs, expenses, invoiced amounts, and overall profit.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>
• Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is Client Profit. In Practice Advantage, there is no comparable report.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Include Write Up/Down in Time and Expense Amounts	Yes/No	Includes write-ups and write-downs in time and expense calculations.
Hide Comma	Yes/No	Includes or excludes comma in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year
Status	=	All

Optional Filters
Available Fields
Accounting Period Date	Client Region	Primary Partner
Billed Hours	Client Sub ID	Profit %
Business Code	Client Type	Real %
Client	Effective Rate	Return Group
Client – Principal	Expenses Cost	Status
Client Bill Manager	Expenses Invoiced	Tax Type
Client Business Unit	Financial Reporting Client Group	Time Cost
Client ID	Gross Profit	Time Invoiced
Client ID.Sub ID	Invoices w/o Progress	Total Cost
Client Name	Line of Business	Transaction Date
Client Office	Manager
Client Primary Service Type	Posted Date

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client Name	Financial Reporting Client Group
Client – Principal	Client Office	Line of Business
Client Bill Manager	Client Primary Service Type	Manager
Client Business Unit	Client Region	Primary Partner
Client ID	Client Sub ID	Return Group
Client ID.Sub ID	Client Type	Tax Type

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Billed Hours	Expenses Invoiced	Time Cost
Client ID	Gross Profit	Time Invoiced
Client Name	Invoiced w/o Progress	Total Cost
Effective Rate	Profit %
Expenses Cost	Real %

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client ID	The client ID.
Client Name	The client name.
Billed Hours	The total hours for billed WIP on posted invoices for the date range selected.
Time Invoiced	The total WIP time amounts billed including write up/down without progress. This amount includes surcharges that have been billed.
Time Cost	The cost rate per staff for billed WIP multiplied by the number of hours billed.
Expenses Invoices	The total of expenses billed on posted invoices for the date range selected including write up/down.
Expenses Cost	The original expense amount.
Invoiced w/o Progress	The total billed WIP + write up/down without progress.
Total Cost	The sum of time cost plus expense cost.
Gross Profit	The invoiced without progress amount minus the total cost.
Profit %	The gross profit divided by the invoiced without progress amount.
Effective Rate	The invoiced without progress amount divided by billed hours.
Real %	The invoiced without progress amount divided by WIP amounts billed without write up/down.

Client Profit Sample Report